﻿<%@ Page Title="" Language="VB" MasterPageFile="~/Master/Site_InnerWeb.master" AutoEventWireup="false" CodeFile="LookupAdmin.aspx.vb" Inherits="admin_general_LookupAdmin" %>

<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="FeaturedContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MainContent" Runat="Server">

    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
        <asp:ListItem Value="0" Selected="True">lkp_CampaignStatus</asp:ListItem>
        <asp:ListItem Value="1">lkp_CampaignTemplate missing</asp:ListItem>
        <asp:ListItem Value="2">lkp_CampaignTemplateDate  missing</asp:ListItem>
        <asp:ListItem Value="3">lkp_CampaignType</asp:ListItem>
        <asp:ListItem Value="4">lkp_CardType missing</asp:ListItem>
        <asp:ListItem Value="5">lkp_Currency</asp:ListItem>
        <asp:ListItem Value="6">lkp_Day missing</asp:ListItem>
        <asp:ListItem Value="7">lkp_EntityType</asp:ListItem>
        <asp:ListItem Value="8">lkp_IntervalUnit missing</asp:ListItem>
        <asp:ListItem Value="9">lkp_ListType</asp:ListItem>
        <asp:ListItem Value="10">lkp_MessageType </asp:ListItem>
        <asp:ListItem Value="11">lkp_MktSourceType missing</asp:ListItem>
        <asp:ListItem Value="12">lkp_Month  missing</asp:ListItem>
        <asp:ListItem Value="13">lkp_Occupation missing</asp:ListItem>
        <asp:ListItem Value="14">lkp_OptinMethod</asp:ListItem>
        <asp:ListItem Value="15">lkp_PopulationMethod missing</asp:ListItem>
        <asp:ListItem Value="16">lkp_SystemFilter missing</asp:ListItem>
        <asp:ListItem Value="17">lkp_SystemMessageGroup missing</asp:ListItem>
        <asp:ListItem Value="18">lkp_SystemMessageGroupItem missing</asp:ListItem>
        <asp:ListItem Value="19">lkp_TargetListColumnList</asp:ListItem>
        <asp:ListItem Value="20">lkp_TrialPlan</asp:ListItem>
        <asp:ListItem Value="21">lkp_UsagePlan</asp:ListItem>
        <asp:ListItem Value="22">lkp_VatRate</asp:ListItem>
        <asp:ListItem Value="23">lkp_Year missing</asp:ListItem>
        <asp:ListItem Value="24">lkp_PaymentMethod</asp:ListItem>
        <asp:ListItem Value="25">lkp_SMS_SentStatus missing</asp:ListItem>
    </asp:DropDownList>
    <asp:MultiView ID="MultiView1" runat="server">
        <asp:View ID="View1" runat="server">
            1.	dbo.lkp_CampaignStatus 
            <asp:GridView ID="GridView1" runat="server" DataSourceID="CampaignStatusODS" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                <Columns>
                    <asp:BoundField DataField="ColumnName" HeaderText="ColumnName" SortExpression="ColumnName" />
                </Columns>
                <EditRowStyle BackColor="#999999" />
                <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                <SortedAscendingCellStyle BackColor="#E9E7E2" />
                <SortedAscendingHeaderStyle BackColor="#506C8C" />
                <SortedDescendingCellStyle BackColor="#FFFDF8" />
                <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="CampaignStatusODS" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_GetTargetListColumnNamesByTargetListIdTableAdapter">
                <SelectParameters>
                    <asp:Parameter Name="TargetListId" Type="Int32" />
                </SelectParameters>
            </asp:ObjectDataSource>
        </asp:View>
        <asp:View ID="View2" runat="server">
            2.	dbo.lkp_CampaignTemplate missing 
                       <asp:GridView ID="GridView2" runat="server" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="Id" DataSourceID="CampaignTemplateODS" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="CampaignTemplateODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_CampaignTemplateSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View3" runat="server">
            3.	dbo.lkp_CampaignTemplateDate missing 
                       <asp:GridView ID="GridView3" runat="server" CellPadding="4" DataSourceID="CampaignTemplateDateODS" ForeColor="#333333" GridLines="None" AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="Id" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="CampaignTemplateId" HeaderText="CampaignTemplateId" SortExpression="CampaignTemplateId" />
                               <asp:BoundField DataField="SendDate" HeaderText="SendDate" SortExpression="SendDate" />
                               <asp:BoundField DataField="SendTime" HeaderText="SendTime" SortExpression="SendTime" />
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="CampaignTemplateDateODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_CampaignTemplateDateSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="CampaignTemplateId" Type="Int32" />
                    <asp:Parameter Name="SendDate" Type="String" />
                    <asp:Parameter DbType="Time" Name="SendTime" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="CampaignTemplateId" Type="Int32" />
                    <asp:Parameter Name="SendDate" Type="String" />
                    <asp:Parameter DbType="Time" Name="SendTime" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View4" runat="server">
            4.	dbo.lkp_CampaignType
 
                       <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="CampaignTypeODS" CellPadding="4" ForeColor="#333333" GridLines="None" AllowSorting="True" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="CampaignTypeODS" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_CampaignTypeSelectTableAdapter" DeleteMethod="Delete" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </DeleteParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>
        </asp:View>
        <asp:View ID="View5" runat="server">
            5. dbo.lkp_CardType missing
                                   <asp:GridView ID="GridView26" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" DataSourceID="CardTypeODS" EmptyDataText="No data to display">
                                       <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                                       <Columns>
                                           <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                                       </Columns>
                                       <EditRowStyle BackColor="#999999" />
                                       <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                       <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                                       <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                                       <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                                       <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                                       <SortedAscendingCellStyle BackColor="#E9E7E2" />
                                       <SortedAscendingHeaderStyle BackColor="#506C8C" />
                                       <SortedDescendingCellStyle BackColor="#FFFDF8" />
                                       <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="CardTypeODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_CampaignTypeSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View6" runat="server">
            6. dbo.lkp_Currency 
                       <asp:GridView ID="GridView5" runat="server" DataSourceID="CurrencyODS" CellPadding="4" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="CurrencyODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_CurrencySelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View7" runat="server">
            7. dbo.lkp_Day missing 
                       <asp:GridView ID="GridView6" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="DayODS" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="DayODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_DaySelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                    <asp:Parameter Name="Name" Type="String" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                    <asp:Parameter Name="Name" Type="String" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View8" runat="server">
            8. dbo.lkp_EntityType 
                       <asp:GridView ID="GridView7" runat="server" DataSourceID="EntityTypeODS" CellPadding="4" ForeColor="#333333" GridLines="None">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="EntityTypeODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_EntityTypeSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View9" runat="server">
            9. dbo.lkp_IntervalUnit missing 
                       <asp:GridView ID="GridView8" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" DataSourceID="IntervalUnitODS" AutoGenerateColumns="False" DataKeyNames="Id" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="IntervalUnitODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_IntervalUnitSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View10" runat="server">
            10. dbo.lkp_ListType 
                       <asp:GridView ID="GridView9" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="ListTypeODS" CellPadding="4" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="ListTypeODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_ListTypeTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View11" runat="server">
            11. dbo.lkp_MessageType 
                       <asp:GridView ID="GridView10" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="MessageTypeODS" CellPadding="4" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="MessageTypeODS" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_MessageTypeSelect_ALLTableAdapter"></asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View12" runat="server">
            12. dbo.lkp_MktSourceType missing 
                       <asp:GridView ID="GridView11" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="MktSourceType" AllowSorting="True" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowEditButton="True" ShowDeleteButton="True"></asp:CommandField>
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id"></asp:BoundField>
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name"></asp:BoundField>
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active"></asp:CheckBoxField>
                           </Columns>

                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="MktSourceType" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_MktSourceTypeSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                    <asp:Parameter Name="Name" Type="String"></asp:Parameter>
                    <asp:Parameter Name="Active" Type="Boolean"></asp:Parameter>
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                    <asp:Parameter Name="Name" Type="String"></asp:Parameter>
                    <asp:Parameter Name="Active" Type="Boolean"></asp:Parameter>
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View13" runat="server">
            13. dbo.lkp_Month missing 
                       <asp:GridView ID="GridView12" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="MonthODS" AllowSorting="True" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowEditButton="True" ShowDeleteButton="True"></asp:CommandField>
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id"></asp:BoundField>
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name"></asp:BoundField>
                           </Columns>

                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="MonthODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_MonthSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Byte"></asp:Parameter>
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String"></asp:Parameter>
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Byte"></asp:Parameter>
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Byte"></asp:Parameter>
                    <asp:Parameter Name="Name" Type="String"></asp:Parameter>
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View14" runat="server">
            14. dbo.lkp_Occupation missing 
                       <asp:GridView ID="GridView13" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" DataSourceID="OccupationODS" AutoGenerateColumns="False" DataKeyNames="Id" AllowSorting="True" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowEditButton="True" ShowDeleteButton="True"></asp:CommandField>
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" InsertVisible="False" SortExpression="Id"></asp:BoundField>
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name"></asp:BoundField>
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active"></asp:CheckBoxField>
                           </Columns>

                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
                       </asp:GridView>
            <asp:ObjectDataSource ID="OccupationODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_OccupationSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String"></asp:Parameter>
                    <asp:Parameter Name="Active" Type="Boolean"></asp:Parameter>
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                    <asp:Parameter Name="Name" Type="String"></asp:Parameter>
                    <asp:Parameter Name="Active" Type="Boolean"></asp:Parameter>
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View15" runat="server">
            15. dbo.lkp_OptinMethod 
                       <asp:GridView ID="GridView14" runat="server" CellPadding="4" DataSourceID="OptinMethodODS" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="OptinMethodODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_OptinMethodTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View16" runat="server">
            16. dbo.lkp_PopulationMethod missing 
                       <asp:GridView ID="GridView15" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="PopulationMethodODS" AllowSorting="True" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowEditButton="True" ShowDeleteButton="True"></asp:CommandField>
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id"></asp:BoundField>
                               <asp:CheckBoxField DataField="QRCode" HeaderText="QRCode" SortExpression="QRCode"></asp:CheckBoxField>
                               <asp:CheckBoxField DataField="Website" HeaderText="Website" SortExpression="Website"></asp:CheckBoxField>
                               <asp:CheckBoxField DataField="MobileWebsite" HeaderText="MobileWebsite" SortExpression="MobileWebsite"></asp:CheckBoxField>
                           </Columns>

                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="PopulationMethodODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_PopulationMethodSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                    <asp:Parameter Name="QRCode" Type="Boolean"></asp:Parameter>
                    <asp:Parameter Name="Website" Type="Boolean"></asp:Parameter>
                    <asp:Parameter Name="MobileWebsite" Type="Boolean"></asp:Parameter>
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                    <asp:Parameter Name="QRCode" Type="Boolean"></asp:Parameter>
                    <asp:Parameter Name="Website" Type="Boolean"></asp:Parameter>
                    <asp:Parameter Name="MobileWebsite" Type="Boolean"></asp:Parameter>
                </UpdateParameters>
            </asp:ObjectDataSource>
            
        </asp:View>
        <asp:View ID="View17" runat="server">
            17. dbo.lkp_SystemFilter missing 
                       <asp:GridView ID="GridView16" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" DataSourceID="SystemFilterODS" AutoGenerateColumns="False" DataKeyNames="Id" AllowSorting="True" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowEditButton="True" ShowDeleteButton="True"></asp:CommandField>
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" InsertVisible="False" SortExpression="Id"></asp:BoundField>
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name"></asp:BoundField>
                               <asp:BoundField DataField="Note" HeaderText="Note" SortExpression="Note"></asp:BoundField>
                               <asp:BoundField DataField="FilterText" HeaderText="FilterText" SortExpression="FilterText"></asp:BoundField>
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active"></asp:CheckBoxField>
                           </Columns>

                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
                       </asp:GridView>
            <asp:ObjectDataSource ID="SystemFilterODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_SystemFilterSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String"></asp:Parameter>
                    <asp:Parameter Name="Note" Type="String"></asp:Parameter>
                    <asp:Parameter Name="FilterText" Type="String"></asp:Parameter>
                    <asp:Parameter Name="Active" Type="Boolean"></asp:Parameter>
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                    <asp:Parameter Name="Name" Type="String"></asp:Parameter>
                    <asp:Parameter Name="Note" Type="String"></asp:Parameter>
                    <asp:Parameter Name="FilterText" Type="String"></asp:Parameter>
                    <asp:Parameter Name="Active" Type="Boolean"></asp:Parameter>
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View18" runat="server">
            18. dbo.lkp_SystemMessageGroup missing 
                       <asp:GridView ID="GridView17" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SystemMessageGroupODS" AllowSorting="True" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" InsertVisible="False" SortExpression="Id"></asp:BoundField>

                               <asp:BoundField DataField="GroupName" HeaderText="GroupName" SortExpression="GroupName"></asp:BoundField>
                               <asp:BoundField DataField="MessageTypeId" HeaderText="MessageTypeId" SortExpression="MessageTypeId"></asp:BoundField>
                               <asp:BoundField DataField="BaseDate" HeaderText="BaseDate" SortExpression="BaseDate"></asp:BoundField>
                               <asp:BoundField DataField="DateAdded" HeaderText="DateAdded" SortExpression="DateAdded"></asp:BoundField>
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active"></asp:CheckBoxField>
                           </Columns>

                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
                       </asp:GridView>
            <asp:ObjectDataSource ID="SystemMessageGroupODS" runat="server" DeleteMethod="Delete" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_SystemMessageGroupSelectTableAdapter">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </DeleteParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32"></asp:Parameter>
                </SelectParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View19" runat="server">
            19. dbo.lkp_SystemMessageGroupItem 
                       <asp:GridView ID="GridView18" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SystemMessageGroupItemODS" CellPadding="4" ForeColor="#333333" GridLines="None" AllowSorting="True" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="MessageGroupId" HeaderText="MessageGroupId" SortExpression="MessageGroupId" />
                               <asp:BoundField DataField="SeqNo" HeaderText="SeqNo" SortExpression="SeqNo" />
                               <asp:BoundField DataField="MessageText" HeaderText="MessageText" SortExpression="MessageText" />
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="SystemMessageGroupItemODS" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_SystemMessageGroupItemSelectTableAdapter" DeleteMethod="Delete" InsertMethod="Insert" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="MessageGroupId" Type="Int32" />
                    <asp:Parameter Name="SeqNo" Type="Byte" />
                    <asp:Parameter Name="MessageText" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="MessageGroupId" Type="Int32" />
                    <asp:Parameter Name="SeqNo" Type="Byte" />
                    <asp:Parameter Name="MessageText" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View20" runat="server">
            20. dbo.lkp_TargetListColumnList 
                       <asp:GridView ID="GridView19" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="TargetListColumnListODS" CellPadding="4" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="ColumnName" HeaderText="ColumnName" SortExpression="ColumnName" />
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="TargetListColumnListODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_TargetListColumnListTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Direction="InputOutput" Name="RETURN_VALUE" Type="Object" />
                    <asp:Parameter Name="ColumnName" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Byte" />
                    <asp:Parameter Name="ColumnName" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View21" runat="server">
            21. dbo.lkp_TrialPlan 
                       <asp:GridView ID="GridView20" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="TrialPlanODS" CellPadding="4" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
                               <asp:BoundField DataField="TrialPlanLengthInDays" HeaderText="TrialPlanLengthInDays" SortExpression="TrialPlanLengthInDays" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="TrialPlanODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_TrialPlanTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Original_Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                    <asp:Parameter Name="TrialPlanLengthInDays" Type="Int32" />
                </InsertParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Active" Type="Boolean" />
                    <asp:Parameter Name="TrialPlanLengthInDays" Type="Int32" />
                    <asp:Parameter Name="Original_Id" Type="Int32" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View22" runat="server">
            22. dbo.lkp_UsagePlan 
                       <asp:GridView ID="GridView21" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="UsagePlanODS" CellPadding="4" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="Note" HeaderText="Note" SortExpression="Note" />
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="UsagePlanODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_UsagePlanTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Original_Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Note" Type="String" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Note" Type="String" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                    <asp:Parameter Name="Original_Id" Type="Int32" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View23" runat="server">
            23. dbo.lkp_VatRate 
                       <asp:GridView ID="GridView22" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="VatRateODS" CellPadding="4" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="StartDate" HeaderText="StartDate" SortExpression="StartDate" />
                               <asp:BoundField DataField="EndDate" HeaderText="EndDate" SortExpression="EndDate" />
                               <asp:BoundField DataField="Rate" HeaderText="Rate" SortExpression="Rate" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="VatRateODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_VatRateSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="StartDate" Type="DateTime" />
                    <asp:Parameter Name="EndDate" Type="DateTime" />
                    <asp:Parameter Name="Rate" Type="Decimal" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="StartDate" Type="DateTime" />
                    <asp:Parameter Name="EndDate" Type="DateTime" />
                    <asp:Parameter Name="Rate" Type="Decimal" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View24" runat="server">
            24. dbo.lkp_Year missing 
                       <asp:GridView ID="GridView23" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" DataSourceID="YearODS" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"></asp:CommandField>
                           </Columns>

                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="YearODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_YearSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int16" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int16" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int16" />
                    <asp:Parameter Name="Name" Type="String" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View25" runat="server">
            25. Pay.lkp_PaymentMethod 
                       <asp:GridView ID="GridView24" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="PaymentMethodODS" CellPadding="4" ForeColor="#333333" GridLines="None" EmptyDataText="No data to display">
                           <AlternatingRowStyle BackColor="White" ForeColor="#284775" />
                           <Columns>
                               <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                               <asp:BoundField DataField="Id" HeaderText="Id" InsertVisible="False" ReadOnly="True" SortExpression="Id" />
                               <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />
                               <asp:CheckBoxField DataField="Active" HeaderText="Active" SortExpression="Active" />
                           </Columns>
                           <EditRowStyle BackColor="#999999" />
                           <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
                           <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
                           <RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
                           <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
                           <SortedAscendingCellStyle BackColor="#E9E7E2" />
                           <SortedAscendingHeaderStyle BackColor="#506C8C" />
                           <SortedDescendingCellStyle BackColor="#FFFDF8" />
                           <SortedDescendingHeaderStyle BackColor="#6F8DAE" />
            </asp:GridView>
            <asp:ObjectDataSource ID="PaymentMethodODS" runat="server" DeleteMethod="Delete" InsertMethod="Insert" OldValuesParameterFormatString="original_{0}" SelectMethod="GetData" TypeName="LogginsLogDSTableAdapters.usp_lkp_PaymentMethodSelectTableAdapter" UpdateMethod="Update">
                <DeleteParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </DeleteParameters>
                <InsertParameters>
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </InsertParameters>
                <SelectParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                </SelectParameters>
                <UpdateParameters>
                    <asp:Parameter Name="Id" Type="Int32" />
                    <asp:Parameter Name="Name" Type="String" />
                    <asp:Parameter Name="Active" Type="Boolean" />
                </UpdateParameters>
            </asp:ObjectDataSource>

        </asp:View>
        <asp:View ID="View26" runat="server">
            26. Sms.lkp_SMS_SentStatus missing 
                       <asp:GridView ID="GridView25" runat="server" EmptyDataText="No data to display"></asp:GridView>
            <asp:ObjectDataSource ID="ObjectDataSource25" runat="server"></asp:ObjectDataSource>

        </asp:View>
    </asp:MultiView>


</asp:Content>

